FOLLOW US
01 - 30 Sep, 2022
Training in e-marketing and e-commerce program

September 2022 – With the support of the European Union (EU), the United Nations Industrial Development Organisation (UNIDO) created an E-marketing and Commerce program to help Georgian pharmaceutical companies with enhancing their digital presence.

The training course was designed for pharmaceutical companies and aimed at developing an e-marketing and commerce strategy, to create the reader's skills in the e-field such as website development, search engine optimization, and e-commerce management.

To achieve this goal, a program was developed that included online training, customized training sessions, and e-marketing guides specifically for bacteriophage and herbal medicine manufacturers.

The training program was organized under the UN Joint Programme on Innovative Action for Private Sector Competitiveness in Georgia. The program is funded by the European Union (EU) with a budget of USD 6 million and implemented by four UN agencies – the United Nations Development Programme (UNDP), the Food and Agriculture Organization of the United Nations (FAO), the United Nations Industrial Development Organization (UNIDO) and the International Organization for Migration (IOM).

This website has been produced with the assistance of the European Union (EU) and the United Nations Industrial Development Organization (UNIDO). Its content is the sole responsibility of The Georgian Biopharmaceutical Cluster and do not necessarily reflect the views of the European Union and the United Nations Industrial Development Organization
8.1.29PHP Version3.84sRequest Duration25MBMemory UsageGET {locale?}/{all}Route
  • warninglog[16:30:05] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (348ms)
  • Application (3.49s)
  • 1 x Application (90.81%)
    3.49s
    1 x Booting (9.05%)
    347.65ms
    8 templates were rendered
    • website.pages.news.show (resources/views/website/pages/news/show.blade.php)21blade
      Params
      0
      model
      1
      section
      2
      post
      3
      breadcrumbs
      4
      language_slugs
      5
      teams_section_post
      6
      teams
      7
      projects
      8
      services
      9
      about_section
      10
      contact
      11
      photo
      12
      news
      13
      partners
      14
      members
      15
      board
      16
      sections
      17
      footerSections
      18
      mainBanner
      19
      cardBanner
      20
      sidebar_menu
    • website.layout (resources/views/website/layout.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
    • website.master (resources/views/website/master.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
    • website.components.head (resources/views/website/components/head.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
    • website.components.header (resources/views/website/components/header.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
    • website.components.FooterBanner (resources/views/website/components/FooterBanner.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
      28
      subSec
      29
      value
      30
      k
    • website.components.footer (resources/views/website/components/footer.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
      28
      subSec
      29
      value
      30
      k
    • website.components.scripts (resources/views/website/components/scripts.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
      28
      subSec
      29
      value
      30
      k
    uri
    GET {locale?}/{all}
    middleware
    locale, web
    controller
    App\Http\Controllers\Website\RoutesController@index
    namespace
    prefix
    {locale?}
    where
    file
    App/Http/Controllers/Website/RoutesController.php:13-39
    212 statements were executed, 170 of which were duplicated, 42 unique332ms
    • select * from `slugs` where `fullSlug` = 'en/training-in-e-marketing-and-e-commerce-program-1' limit 1
      6.06ms/App/Http/Controllers/Website/RoutesController.php:17pharmacl_phar
      Metadata
      Bindings
      • 0. en/training-in-e-marketing-and-e-commerce-program-1
      Backtrace
      • 15. /App/Http/Controllers/Website/RoutesController.php:17
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `posts` where `posts`.`id` = 213 limit 1
      1.01ms/App/Http/Controllers/Website/RoutesController.php:23pharmacl_phar
      Metadata
      Bindings
      • 0. 213
      Backtrace
      • 19. /App/Http/Controllers/Website/RoutesController.php:23
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `post_translations` where `post_translations`.`post_id` = 213 and `post_translations`.`post_id` is not null
      1.05ms/App/Models/Post.php:106pharmacl_phar
      Metadata
      Bindings
      • 0. 213
      Backtrace
      • 18. /App/Models/Post.php:106
      • 20. /App/Models/Post.php:113
      • 21. /App/Http/Controllers/Website/PagesController.php:398
      • 22. /App/Http/Controllers/Website/RoutesController.php:31
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `slugs` where `slugable_type` = 'App\Models\Post' and `slugable_id` = 213 and `locale` = 'en' limit 1
      930μs/App/Models/Post.php:67pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Post
      • 1. 213
      • 2. en
      Backtrace
      • 15. /App/Models/Post.php:67
      • 16. /App/Http/Controllers/Website/PagesController.php:406
      • 17. /App/Http/Controllers/Website/RoutesController.php:31
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    • select * from `sections` where `id` = 92 limit 1
      790μs/App/Http/Controllers/Website/PagesController.php:410pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:410
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (92)
      690μs/App/Http/Controllers/Website/PagesController.php:410pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:410
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      780μs/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. /App/Http/Controllers/Website/PagesController.php:413
      • 17. /App/Http/Controllers/Website/RoutesController.php:31
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    • select * from `posts` where `section_id` = 213 and `active_on_home` = 1
      790μs/App/Http/Controllers/Website/PagesController.php:419pharmacl_phar
      Metadata
      Bindings
      • 0. 213
      • 1. 1
      Backtrace
      • 14. /App/Http/Controllers/Website/PagesController.php:419
      • 15. /App/Http/Controllers/Website/RoutesController.php:31
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select `posts`.*, `post_translations`.`text`, `post_translations`.`desc`, `post_translations`.`title`, `post_translations`.`locale_additional`, `post_translations`.`slug` from `posts` inner join `post_translations` on `posts`.`id` = `post_translations`.`post_id` where `posts`.`id` = 213 and `post_translations`.`locale` = 'en' limit 1
      1.11ms/App/Http/Controllers/Website/PagesController.php:428pharmacl_phar
      Metadata
      Bindings
      • 0. 213
      • 1. en
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:428
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_files` where `post_files`.`post_id` in (213)
      1.21ms/App/Http/Controllers/Website/PagesController.php:428pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:428
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 92 limit 1
      1.09ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:431
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (92)
      1.03ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:431
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (92) order by `date` desc
      1.2ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:431
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (177, 178, 179, 180, 181, 195, 213, 446) and `locale` = 'en'
      1.73ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:431
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 92 limit 1
      1ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:432
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (92)
      1.1ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:432
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (92) order by `date` desc
      1.31ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:432
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (177, 178, 179, 180, 181, 195, 213, 446) and `locale` = 'en'
      1.71ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:432
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 7 limit 1
      1.32ms/App/Http/Controllers/Website/PagesController.php:433pharmacl_phar
      Metadata
      Bindings
      • 0. 7
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:433
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 6 limit 1
      1.33ms/App/Http/Controllers/Website/PagesController.php:434pharmacl_phar
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:434
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 3 limit 1
      1.29ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:435
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (32)
      1.43ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:435
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (32) order by `date` desc
      1.46ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:435
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (65) and `locale` = 'en'
      1.7ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:435
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 4 limit 1
      1.22ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:436
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (90)
      1.15ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:436
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (90) order by `date` desc
      1.3ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:436
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (158) and `locale` = 'en'
      1.42ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:436
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 2 limit 1
      1.26ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Bindings
      • 0. 2
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:437
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (81)
      1.47ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:437
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (81) order by `date` desc
      1.6ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:437
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (123, 196, 197, 435, 445, 448, 449) and `locale` = 'en'
      1.79ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:437
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 92 limit 1
      1.21ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:438
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (92)
      1.3ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:438
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (92) order by `date` desc
      1.57ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:438
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (177, 178, 179, 180, 181, 195, 213, 446) and `locale` = 'en'
      1.69ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:438
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 15 limit 1
      1.31ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Bindings
      • 0. 15
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:439
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (87)
      1.33ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:439
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (87) order by `date` desc
      1.48ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:439
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (145, 154) and `locale` = 'en'
      1.55ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:439
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 17 and `id` = 92 limit 1
      1.44ms/App/Http/Controllers/Website/PagesController.php:440pharmacl_phar
      Metadata
      Bindings
      • 0. 17
      • 1. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:440
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 9 limit 1
      1.32ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Bindings
      • 0. 9
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:441
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (78)
      1.35ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:441
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (78) order by `date` desc
      1.32ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:441
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (116, 163) and `locale` = 'en'
      1.56ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:441
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • update `posts` set `views` = 397, `posts`.`updated_at` = '2025-01-03 16:30:04' where `id` = 213
      4.56ms/App/Http/Controllers/Website/PagesController.php:445pharmacl_phar
      Metadata
      Bindings
      • 0. 397
      • 1. 2025-01-03 16:30:04
      • 2. 213
      Backtrace
      • 13. /App/Http/Controllers/Website/PagesController.php:445
      • 14. /App/Http/Controllers/Website/RoutesController.php:31
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      3.3ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.16ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.99ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.37ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      980μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.49ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      3.08ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.28ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.55ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.74ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.78ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.61ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `post_translations` where `post_translations`.`post_id` = 213 and `post_translations`.`post_id` is not null
      1.63ms/App/Models/Post.php:106pharmacl_phar
      Metadata
      Bindings
      • 0. 213
      Backtrace
      • 18. /App/Models/Post.php:106
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:317
      • 23. view::dacfb6f22dc64083a76cc3ce8a8bc2927acd17bd:31
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      3.01ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.58ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.77ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.31ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.03ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.48ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.54ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.3ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.06ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.66ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.82ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.45ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.57ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.87ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.57ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.09ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      890μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.26ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.26ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.04ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.16ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.32ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.4ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.36ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.43ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.8ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.7ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.15ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      990μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.38ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.47ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.2ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.93ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.61ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.74ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.39ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.7ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.38ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      2.04ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.27ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.07ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.53ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.58ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.17ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.12ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.71ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.56ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.39ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.51ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 101 and `locale` = 'en' limit 1
      1.65ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 101
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 115 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 115
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.51ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.4ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 111 and `locale` = 'en' limit 1
      1.58ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 111
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 103 and `locale` = 'en' limit 1
      1.48ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 103
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 85 and `locale` = 'en' limit 1
      1.32ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 85
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.32ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 105 and `locale` = 'en' limit 1
      1.38ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 105
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.39ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.48ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 96 and `locale` = 'en' limit 1
      1.4ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 96
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.3ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 118 and `locale` = 'en' limit 1
      1.35ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 118
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.63ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 107 and `locale` = 'en' limit 1
      1.57ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 107
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 108 and `locale` = 'en' limit 1
      1.38ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 108
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.36ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.63ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 80 and `locale` = 'en' limit 1
      1.72ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 80
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.37ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.31ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 101 and `locale` = 'en' limit 1
      1.42ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 101
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 115 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 115
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.52ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.29ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 111 and `locale` = 'en' limit 1
      1.35ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 111
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.46ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 103 and `locale` = 'en' limit 1
      1.61ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 103
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 85 and `locale` = 'en' limit 1
      1.39ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 85
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 105 and `locale` = 'en' limit 1
      1.63ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 105
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.56ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 96 and `locale` = 'en' limit 1
      1.72ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 96
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.36ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 118 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 118
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 107 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 107
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 108 and `locale` = 'en' limit 1
      1.38ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 108
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 102 and `locale` = 'en' limit 1
      1.72ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 102
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.53ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.85ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 80 and `locale` = 'en' limit 1
      1.6ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 80
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.72ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      3.15ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.73ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      2.14ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.27ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      850μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.35ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.28ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.08ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.99ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.55ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.44ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.34ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      3.23ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.36ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.85ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.1ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      900μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.37ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.56ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.47ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.31ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.71ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.89ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.59ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.39ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 32 and `section_translations`.`section_id` is not null
      1.51ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 32
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.33ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 89 and `section_translations`.`section_id` is not null
      1.33ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 89
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 82 and `section_translations`.`section_id` is not null
      1.38ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 82
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 104 and `section_translations`.`section_id` is not null
      1.3ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 104
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.59ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 91 and `section_translations`.`section_id` is not null
      1.55ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 91
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.62ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 92 and `section_translations`.`section_id` is not null
      1.59ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 93 and `section_translations`.`section_id` is not null
      1.32ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 93
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.37ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 84 and `section_translations`.`section_id` is not null
      1.41ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 84
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.32ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 81 and `section_translations`.`section_id` is not null
      1.3ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 81
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.3ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 78 and `section_translations`.`section_id` is not null
      1.45ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 78
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.55ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 90 and `section_translations`.`section_id` is not null
      1.3ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 90
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.9ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.34ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.74ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.21ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      860μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.62ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.49ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.22ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.02ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.61ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.66ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.41ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    App\Models\BannerTranslation
    32
    App\Models\Banner
    40
    App\Models\MenuSection
    104
    App\Models\PostFile
    1
    App\Models\SectionTranslation
    288
    App\Models\Section
    337
    App\Models\PostTranslation
    41
    App\Models\Post
    39
    App\Models\Slug
    61
        locale
        en
        _token
        5d0LxWIX5rspDCU1exfSuAj6KLVOaHtpAdTtMzfy
        _previous
        array:1 [ "url" => "https://pharmacluster.org/en/training-in-e-marketing-and-e-commerce-program-1"...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /en/training-in-e-marketing-and-e-commerce-program-1
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "pharmacluster.org" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_server
        0 of 0
        array:75 [ "USER" => "pharmacl" "HOME" => "/home/pharmacl" "SCRIPT_NAME" => "/public/index.php" "REQUEST_URI" => "/en/training-in-e-marketing-and-e-commerce-program-1" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/public/en/training-in-e-marketing-and-e-commerce-program-1" "REMOTE_PORT" => "32719" "SCRIPT_FILENAME" => "/home/pharmacl/domains/pharmacluster.org/private_html/public/index.php" "SERVER_ADMIN" => "webmaster@pharmacluster.org" "CONTEXT_DOCUMENT_ROOT" => "/home/pharmacl/domains/pharmacluster.org/private_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/pharmacl/domains/pharmacluster.org/private_html" "REMOTE_ADDR" => "3.145.44.58" "SERVER_PORT" => "443" "SERVER_ADDR" => "91.239.206.137" "SERVER_NAME" => "pharmacluster.org" "SERVER_SOFTWARE" => "Apache/2" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "HTTP_HOST" => "pharmacluster.org" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "proxy-nokeepalive" => "1" "H2_STREAM_TAG" => "585586-2719-1" "H2_STREAM_ID" => "1" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "pharmacluster.org" "HTTPS" => "on" "UNIQUE_ID" => "Z3fYS_ZnVq38qjFCdeC3NwAAKC8" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "585586-2719-1" "REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2PUSH" => "off" "REDIRECT_HTTP2" => "on" "REDIRECT_SSL_TLS_SNI" => "pharmacluster.org" "REDIRECT_HTTPS" => "on" "REDIRECT_UNIQUE_ID" => "Z3fYS_ZnVq38qjFCdeC3NwAAKC8" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_REDIRECT_H2_STREAM_TAG" => "585586-2719-1" "REDIRECT_REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_REDIRECT_H2_PUSHED" => "" "REDIRECT_REDIRECT_H2_PUSH" => "off" "REDIRECT_REDIRECT_H2PUSH" => "off" "REDIRECT_REDIRECT_HTTP2" => "on" "REDIRECT_REDIRECT_SSL_TLS_SNI" => "pharmacluster.org" "REDIRECT_REDIRECT_HTTPS" => "on" "REDIRECT_REDIRECT_UNIQUE_ID" => "Z3fYS_ZnVq38qjFCdeC3NwAAKC8" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1735907403.4529 "REQUEST_TIME" => 1735907403 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 03 Jan 2025 12:30:07 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IllMODYvV1U4YzdYM05sWVdTaGJCanc9PSIsInZhbHVlIjoiUnFudU5HY3R1Q3YyM29mM3d5TGZoUnQ3RFpWWHJ2dTFwYysvb0l6anR4OEFpRVgrNFE0QlJROHZvR0dBYWdWa09CVmd1NEliRUhxZWVYcXZrTTBRWDN1V3VFWVJPVTRsZXl5aXRzRmx6cmxONVRreExnVjE3ZFBiWGdyRUZEcXciLCJtYWMiOiJiZmI1ZDYwODI0Y2E1YjYyYTAwYjZjMzc5YTQ3OGI4OGVlMjc0NWE2OTRjZjFmY2M0ZjRiMjBjOTM0ZTI1NWQxIiwidGFnIjoiIn0%3D; expires=Fri, 03-Jan-2025 14:30:07 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IllMODYvV1U4YzdYM05sWVdTaGJCanc9PSIsInZhbHVlIjoiUnFudU5HY3R1Q3YyM29mM3d5TGZoUnQ3RFpWWHJ2dTFwYysvb0l6anR4OEFpRVgrNFE0QlJROHZvR0dBYWdWa09CVmd1N" 1 => "geopharmacy_session=eyJpdiI6InNkYmgwN1Y1WWlZQ2Z5Sk42MUxrUXc9PSIsInZhbHVlIjoiczd3THF5bXY5aXJjVW9mVFZ6MGdGd0s2VDlidXExUnZIVVFjRGtENlNyTTFKVkJnTzl1Y1MxVWhiejJFb0lVdldVRjB0UmYvMjBPbXMvYXlwcWgzTnRxREtmcDlILzlhOXV5NHRCaStBaDNxclJQbEl5ZkMwbUUxREcxTWg1QXEiLCJtYWMiOiI5M2IyODM1ZjAzZmMyNjUxZDg1MGEyMTFmMzY2MjA2YmE2OTZhYjg3YTA4MmJiN2Y0NTJmY2Q2M2FjNjA5NzYxIiwidGFnIjoiIn0%3D; expires=Fri, 03-Jan-2025 14:30:07 GMT; Max-Age=7200; path=/; httponly; samesite=laxgeopharmacy_session=eyJpdiI6InNkYmgwN1Y1WWlZQ2Z5Sk42MUxrUXc9PSIsInZhbHVlIjoiczd3THF5bXY5aXJjVW9mVFZ6MGdGd0s2VDlidXExUnZIVVFjRGtENlNyTTFKVkJnTzl1Y1MxVWhiejJFb0lV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IllMODYvV1U4YzdYM05sWVdTaGJCanc9PSIsInZhbHVlIjoiUnFudU5HY3R1Q3YyM29mM3d5TGZoUnQ3RFpWWHJ2dTFwYysvb0l6anR4OEFpRVgrNFE0QlJROHZvR0dBYWdWa09CVmd1NEliRUhxZWVYcXZrTTBRWDN1V3VFWVJPVTRsZXl5aXRzRmx6cmxONVRreExnVjE3ZFBiWGdyRUZEcXciLCJtYWMiOiJiZmI1ZDYwODI0Y2E1YjYyYTAwYjZjMzc5YTQ3OGI4OGVlMjc0NWE2OTRjZjFmY2M0ZjRiMjBjOTM0ZTI1NWQxIiwidGFnIjoiIn0%3D; expires=Fri, 03-Jan-2025 14:30:07 GMT; path=/XSRF-TOKEN=eyJpdiI6IllMODYvV1U4YzdYM05sWVdTaGJCanc9PSIsInZhbHVlIjoiUnFudU5HY3R1Q3YyM29mM3d5TGZoUnQ3RFpWWHJ2dTFwYysvb0l6anR4OEFpRVgrNFE0QlJROHZvR0dBYWdWa09CVmd1N" 1 => "geopharmacy_session=eyJpdiI6InNkYmgwN1Y1WWlZQ2Z5Sk42MUxrUXc9PSIsInZhbHVlIjoiczd3THF5bXY5aXJjVW9mVFZ6MGdGd0s2VDlidXExUnZIVVFjRGtENlNyTTFKVkJnTzl1Y1MxVWhiejJFb0lVdldVRjB0UmYvMjBPbXMvYXlwcWgzTnRxREtmcDlILzlhOXV5NHRCaStBaDNxclJQbEl5ZkMwbUUxREcxTWg1QXEiLCJtYWMiOiI5M2IyODM1ZjAzZmMyNjUxZDg1MGEyMTFmMzY2MjA2YmE2OTZhYjg3YTA4MmJiN2Y0NTJmY2Q2M2FjNjA5NzYxIiwidGFnIjoiIn0%3D; expires=Fri, 03-Jan-2025 14:30:07 GMT; path=/; httponlygeopharmacy_session=eyJpdiI6InNkYmgwN1Y1WWlZQ2Z5Sk42MUxrUXc9PSIsInZhbHVlIjoiczd3THF5bXY5aXJjVW9mVFZ6MGdGd0s2VDlidXExUnZIVVFjRGtENlNyTTFKVkJnTzl1Y1MxVWhiejJFb0lV" ] ]
        session_attributes
        0 of 0
        array:5 [ "locale" => "en" "_token" => "5d0LxWIX5rspDCU1exfSuAj6KLVOaHtpAdTtMzfy" "_previous" => array:1 [ "url" => "https://pharmacluster.org/en/training-in-e-marketing-and-e-commerce-program-1" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]